UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78F+BP7BAPRL8XtjBr0WOWftk4I8uYAqOw3Ra5fkjok='
WHERE
key_id = 'f95c07ea33ac8a7a16f92e47fa6d9ab97d3fbf7ecbae6a705d23eb20a58ff97a'
AND (
token = '78F+BP7BAPRL8XtjBr0WOWftk4I8uYAqOw3Ra5fkjok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)