SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '946ba3f11ade79a34f04056c635879f2ed9e4d542d20dde1e3bb1f31270fad31' 
  AND token = '9iDjt+L6CYHdhNVtfXWdimKOmL9hYcAY9rC2qoJHwW4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}