UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xeWO/DviKGejcvx4l4DqD6G1q1XOVo4RNFmkba/gd4A='
WHERE
key_id = 'd99c08869107e7b7b9616186724ca6908db6e1f529b8a79fbe3c178aa78d44e9'
AND (
token = 'xeWO/DviKGejcvx4l4DqD6G1q1XOVo4RNFmkba/gd4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)