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