SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c7dc7a5dd1c12b8ea939f2ee8bebf51910a771fa1d518d0d552a28f2e37b1033' 
  AND token = '6GPp0dgZ9SsPw8ogeyA/prn4jDTn+eNbIo9LdgNtXV8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

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