UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rBBWMwbEDO41PJwO/7bysuDzNs0OaIxd6DsutkM4j80=' 
WHERE 
  key_id = '00509c4c520c7dff0b1691de6f8bf6b365aa3f28fc8a5f62c248e92e0ac57267' 
  AND (
    token = 'rBBWMwbEDO41PJwO/7bysuDzNs0OaIxd6DsutkM4j80=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034