UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c2NrotZ4eiXT+DAkpxdNWl1THVEt2GhAIbOGUVHA/cs='
WHERE
key_id = 'fd488f9d5d5d41b28720488470e7729bfda1d33110229d186df7a7d9514635a7'
AND (
token = 'c2NrotZ4eiXT+DAkpxdNWl1THVEt2GhAIbOGUVHA/cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)