UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jOcs2F0H8DOGZqWoNo1kpvthQltUweRAQVr2wM3sRGw='
WHERE
key_id = '768629f33523bdded526665b80e25aca697c6e6687242df2167098707dd0bfe8'
AND (
token = 'jOcs2F0H8DOGZqWoNo1kpvthQltUweRAQVr2wM3sRGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)