UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E6hGNxb1kOhReVq9GY3r5CN20S3X6O5RJk3vsErcJZw='
WHERE
key_id = 'a81f027365e34f7c5b0c71b6de524426d989b4287c9423f00b4ca2380a991298'
AND (
token = 'E6hGNxb1kOhReVq9GY3r5CN20S3X6O5RJk3vsErcJZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)