UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NkIn43juzaZAJBxkkZwzWVxQ10mmzLNsmxV6dlnTq68='
WHERE
key_id = 'adef15e0c5c0a5ea49b085ed4ce84618824187331700f5127c15922409168298'
AND (
token = 'NkIn43juzaZAJBxkkZwzWVxQ10mmzLNsmxV6dlnTq68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)