UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'enCE/TtQ0HfMqM1GSeTvNqGxPWJJUOSX98h7evbywA4='
WHERE
key_id = 'ca805fc5aa6ca5558cc6dbf28d4a5a9bbf10710516c7be05c837f74ff6ae912a'
AND (
token = 'enCE/TtQ0HfMqM1GSeTvNqGxPWJJUOSX98h7evbywA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)