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