UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'joiqH6UaS/5rddBQGdOPJeFbYITACeuwjk7/Dj7rXu4='
WHERE
key_id = '487cc01946d1abff63a3b2ee99a9b710b3e41cd26d43a76246b5eb083d23e2f1'
AND (
token = 'joiqH6UaS/5rddBQGdOPJeFbYITACeuwjk7/Dj7rXu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)