UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHEgIibmOHlXlLnXbFC7zFcdufL5vmgzwrbcJ6arfCA='
WHERE
key_id = '892641618d88b81f69479a51d6408655466e750545bebb7774fe36effc7c4290'
AND (
token = 'zHEgIibmOHlXlLnXbFC7zFcdufL5vmgzwrbcJ6arfCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)