SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '578de219dcf728e0be09577dc676f9576a45cc8e6a1b3d77e14fc0d32d1589b8' 
  AND token = '5BaBaYlVCOn7c6YE36eEblZbQmeXnCBdsMLqrgpne+o=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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