UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mkPkW/iKydg4p9NnA7mdQRCgJ2bO7kAd0ZG1QFEK5zw='
WHERE
key_id = 'f1d40b92f60520a8a5d140b1c6af5846f0e4d029344448d065233df258ed53a8'
AND (
token = 'mkPkW/iKydg4p9NnA7mdQRCgJ2bO7kAd0ZG1QFEK5zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)