UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6wJigmOjq7v+eLAuJCA/NwInMHPhCqwTb9DX5lJ1+iU='
WHERE
key_id = '5a15d5948b9730a1abb50a2e4735aa758dccfb180c1a40916df63d9458e7a959'
AND (
token = '6wJigmOjq7v+eLAuJCA/NwInMHPhCqwTb9DX5lJ1+iU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)