UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tNGyyiH1sfawsXk2V2wNxCX0mWYYbh1rOpfJ6wUx7ZU='
WHERE
key_id = '27da5d84eecbaffc4b59823969ac66350aaaddfc09b8bc9c3a57ec2e50d38144'
AND (
token = 'tNGyyiH1sfawsXk2V2wNxCX0mWYYbh1rOpfJ6wUx7ZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)