UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thZE4WpIIIp+DCRLcAiIOAgDU2iWj5Gwkr+qP8zajcw='
WHERE
key_id = '087b68808a30e4e41fa15e3ba43d6ac6a25c4e317d9c56608d1071861b7876a2'
AND (
token = 'thZE4WpIIIp+DCRLcAiIOAgDU2iWj5Gwkr+qP8zajcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)