UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VhvNzCE8ttGiJa4N6Uxwby23Te6CfBawb5dbIyDgrKE='
WHERE
key_id = '2327e15d46176db76ab0bf85c3ae09fef2843bde2c33423ce28003eb56784979'
AND (
token = 'VhvNzCE8ttGiJa4N6Uxwby23Te6CfBawb5dbIyDgrKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)