UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '97WKYi85femvRpU+7Dxu6eZcFAbrciWwy9ueTAspAMU='
WHERE
key_id = 'a3f12c2ae927314edd5ae4262eb50dcd771d06b072697e2ef8427638f6f317c4'
AND (
token = '97WKYi85femvRpU+7Dxu6eZcFAbrciWwy9ueTAspAMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)