UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/1QEMnFFkbS/XTZ9lsznUISckUv5SLnY6p2RX8RwQak='
WHERE
key_id = 'ceb8675e9a377546a6215825cbac72abd578e81f6fec78f720e46e93864efa0d'
AND (
token = '/1QEMnFFkbS/XTZ9lsznUISckUv5SLnY6p2RX8RwQak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)