UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9ha1H06iSVvJF2f/8RNyzB3M8m4NQFFBALE5rX8KOA='
WHERE
key_id = '801b17c02f8f325abb9ce8c2827edf505344d1c0bf4f8926983b47c96c8cdeae'
AND (
token = 'b9ha1H06iSVvJF2f/8RNyzB3M8m4NQFFBALE5rX8KOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)