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

Query time 0.00049