UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RX3j8XauVa0okKX5hw7Ge1WTPul01Ee2d68L5zFeMqw='
WHERE
key_id = '642c39f613bc0fb0b80c7459ad0712ce29ef975b28fdce2ae526901e089c4fb6'
AND (
token = 'RX3j8XauVa0okKX5hw7Ge1WTPul01Ee2d68L5zFeMqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)