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