UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TZ0fiNm0mUX8V2YSTRjZVRYjoYsbCSv75lCt7ZQK6ok='
WHERE
key_id = '222e4ee77d1a0cb591486366d7929af32e9b99a9eba3514f09f7fe2e15579f27'
AND (
token = 'TZ0fiNm0mUX8V2YSTRjZVRYjoYsbCSv75lCt7ZQK6ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)