UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/oWNBul8HqhS5Udn7+3OAI4IVzYqu6WPvvuT6kJ++i8='
WHERE
key_id = '28a2fe05d817ac239a48249c38f61bc7004cedbee304e12fec845f943ab214fd'
AND (
token = '/oWNBul8HqhS5Udn7+3OAI4IVzYqu6WPvvuT6kJ++i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)