UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+Aw5h6sSbVEx7ky8DOQ7jXhzZWGqs/lEpxmkzV1l1os=' 
WHERE 
  key_id = '17bf758c5a44bde18d43f3d787ea8e1cba7adea50e09d75adb8aa8138c9cfb9d' 
  AND (
    token = '+Aw5h6sSbVEx7ky8DOQ7jXhzZWGqs/lEpxmkzV1l1os=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032