UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8EWZDohsUGaVeoZiAiqMwGIDPWnQdJa9OTaG4sGO4A='
WHERE
key_id = 'c6caaf2dfbff64d8e5a4b60372bc093b9a1a9e8949be93d8a6df5e62eb49071c'
AND (
token = '/8EWZDohsUGaVeoZiAiqMwGIDPWnQdJa9OTaG4sGO4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)