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