SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '755dce7b251e187c701f08d6dc3a1e79f6bba6b720fe5392a54bd141f0c409d8' 
  AND token = '9NoRTVOBg3pZ6tJUdOabA+JeNp4mqAhsrZCbxQ4Gs7Y=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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