UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEgRUVaKMqTSRZZyMD+P56o2n7u0fhvfESqSFmQ2AH4='
WHERE
key_id = 'b5dfd6166bdedfcd4be852b50071e109f4075a260ca7ff30613d4483e4934ced'
AND (
token = 'XEgRUVaKMqTSRZZyMD+P56o2n7u0fhvfESqSFmQ2AH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)