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