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

Query time 0.00018