SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e50bce39e378ec9e7680a1591413441271410105383152fedfe1d89ac30fc403' 
  AND token = 'aYrWrI16rKlqDhr28oV2s2gWb2qOPbCopsgGZlS+0MQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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