UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XziWyhvJ+t1PdDgJMwaLdVHTzNYnW5EB0U7ZhdLrApY='
WHERE
key_id = 'a7f721fd23919915f92b7d968e6863d8c9f848d95d3c0267d98f446573c07c2f'
AND (
token = 'XziWyhvJ+t1PdDgJMwaLdVHTzNYnW5EB0U7ZhdLrApY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)