UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tK1QCfQ1BEkHgdqefi97nCxt1Co/AWW/FFvHL8gKIyE='
WHERE
key_id = 'f629f548d9d9152c692a719d64bd09f04a9e937ecb183c835e178546eb73cf19'
AND (
token = 'tK1QCfQ1BEkHgdqefi97nCxt1Co/AWW/FFvHL8gKIyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)