UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CAk2KBePZaR8Lf0NUd/wsv0PBzTCXp46zXI09sWBW6c='
WHERE
key_id = '3049dc567970ea02b72d555b713cc89a0d91df4dd83ad2ef5ab821624d77ca4c'
AND (
token = 'CAk2KBePZaR8Lf0NUd/wsv0PBzTCXp46zXI09sWBW6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)